
If Exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_DispatchMode') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_DispatchMode
END
GO
	CREATE VIEW V_DispatchMode
	AS 
	SELECT [Guid],NAME,IsPayArrived,SafeCost,Formula,OrderID,DispatchType
	FROM ShopNum1_DispatchMode
	WHERE IsDeleted=0
